How to: Prevent users from updating records in a form.
Solution:
In the Form Design view, use the 'Allow Edits', 'Allow Deletions', and 'Allow Additions' property boxes in the property sheet of the form to prevent users from updating records in a form.
1) If the Database window is not activated, activate the Database window.
2) Click the 'Forms' tab in the Database window.
Forms tab
3) Select the desired form from the list box. (The selected form is highlighted.)
4) Click 'Design'. (The selected form appears in Design view, and the floating Toolbox appears.)
5) Click on the form selector.
Single click on form selector.
6) Select the 'View' menu and select 'Properties'.
7) Click the 'Data' tab.
8) Click 'Allow Edits' box. (A down arrow appears.)
9) Click down arrow. (A drop-down list appears.)
10) Select 'No' from the 'Allow Edit' drop-down list.
11) Click 'Allow Deletions' box. (A down arrow appears.)
12) Click down arrow. (A drop-down list appears.)
13) Select 'No' from the 'Allow Deletions' drop-down list.
14) Click 'Allow Additions' box. (A down arrow appears.)
15) Click down arrow. (A drop-down list appears.)
16) Select 'No' from the 'Allow Additions' drop-down list.
17) Select the 'File' menu and select 'Save' to save the form.
